/*
 Navicat Premium Data Transfer

 Source Server         : root@139.196.125.197
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : 139.196.125.197
 Source Database       : xtp

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 07/07/2017 12:02:04 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `app`
-- ----------------------------
DROP TABLE IF EXISTS `app`;
CREATE TABLE `app` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(50) DEFAULT NULL COMMENT '编码-code',
  `Name` varchar(50) DEFAULT NULL,
  `Token` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `app`
-- ----------------------------
BEGIN;
INSERT INTO `app` VALUES ('1', 'xtp', 'xtp权限管理', 'CJzdWIiOiJ7XCJ1c2VySDkwMTUeyJhbGciOiJI'), ('2', 'ipmes', 'ipmes', 'eyJhbGciOiJIUzI1NiJ9NDkwMTUyNDk4LCJzd'), ('3', 'iLeanProcess', '精益生产车间看板', null), ('4', 'xtc', '分布式缓存管理', 'CIiOiw2iOiJPTU1O1c4VySDkyJ2dWJ3XCXhbGc'), ('5', 'crrc', 'crrc', null), ('6', 'prm5', 'prm5', null);
COMMIT;

-- ----------------------------
--  Table structure for `appfavorite`
-- ----------------------------
DROP TABLE IF EXISTS `appfavorite`;
CREATE TABLE `appfavorite` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `AppId` int(11) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `appfavorite`
-- ----------------------------
BEGIN;
INSERT INTO `appfavorite` VALUES ('3', '1', '1'), ('4', '1', '2'), ('5', '1', '3');
COMMIT;

-- ----------------------------
--  Table structure for `dict`
-- ----------------------------
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `Type` varchar(50) NOT NULL DEFAULT '' COMMENT '类型',
  `Key` varchar(50) NOT NULL DEFAULT '' COMMENT '键',
  `Value` varchar(100) NOT NULL DEFAULT '' COMMENT '值',
  `CreateDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='数据字典';

-- ----------------------------
--  Records of `dict`
-- ----------------------------
BEGIN;
INSERT INTO `dict` VALUES ('1', 'datarule_symbol', '=', '=', '2016-03-01 22:42:05'), ('2', 'datarule_symbol', '>', '>', '2016-03-01 22:42:21'), ('3', 'datarule_symbol', '<', '<', '2016-03-01 22:42:28'), ('6', 'db_source', 'zcurd_base', '基本库', '2016-09-18 17:25:49'), ('7', 'db_source', 'zcurd_busi', '业务库', '2016-09-18 17:25:54');
COMMIT;

-- ----------------------------
--  Table structure for `ext`
-- ----------------------------
DROP TABLE IF EXISTS `ext`;
CREATE TABLE `ext` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `tableName` int(11) DEFAULT NULL,
  `columnName` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `Id` int(50) NOT NULL AUTO_INCREMENT,
  `Type` varchar(50) DEFAULT NULL,
  `Centent` varchar(50) DEFAULT NULL,
  `UserId` int(50) DEFAULT NULL,
  `UserName` varchar(50) DEFAULT NULL,
  `CreateDate` varchar(50) DEFAULT NULL,
  `IP` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `AppId` int(11) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `URL` varchar(50) DEFAULT NULL,
  `ParentId` int(11) DEFAULT NULL,
  `Icon` varchar(50) DEFAULT NULL,
  `ParentFlag` bit(1) DEFAULT NULL,
  `DisplayFlag` bit(1) DEFAULT NULL,
  `Sort` int(11) DEFAULT NULL,
  `DeleteFlag` bit(1) DEFAULT NULL,
  `Type` int(6) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('1', '2', 'A', '基础信息管理', null, '0', 'fa fa-bank', b'1', b'1', '1', b'1', '2'), ('2', '2', '用户管理', '用户管理', '/user', '1', 'fa fa-user', b'0', b'1', '2', b'1', '2'), ('3', '2', '报表中心', '报表中心', 'http://www.qq.com', '0', 'fa fa-address-book-o', b'1', b'1', '1', b'1', '2'), ('4', '2', '日报表', '日报表', 'http://www.126.com', '3', 'fa fa-address-book-o', b'0', b'1', '2', b'1', '2'), ('5', '2', '月报表', '月报表', 'http://www.hao123.com', '3', 'fa fa-address-book-o', b'0', b'1', '3', b'1', '2'), ('6', '2', '应用管理', '应用管理', '/app', '1', 'fa fa-tag', b'0', b'1', '2', b'1', '2'), ('7', '2', '菜单管理', '菜单管理', '/menu', '1', 'fa fa-book', b'0', b'1', '3', b'1', '2'), ('8', '2', '角色管理', '角色管理', '/role', '1', 'fa fa-cubes', b'0', b'1', '4', b'1', '2'), ('16', '2', '基础信息', '基础信息', '/', '0', 'fa fa-bank', b'1', b'1', '1', b'1', '2'), ('17', '2', '用户管理', '用户管理', '/user', '16', 'fa fa-address-book', b'1', b'1', '1', b'1', null), ('18', '24013', '测试内容32kj', '测试内容p2ki', '测试内容x4d4', '88661', '测试内容xrdn', b'0', b'0', '65085', b'1', '68010'), ('19', '2', '角色管理', '角色管理', '/role', '16', 'fa fa-anchor', b'0', b'1', '2', b'1', null), ('20', '2', '物料类型', '物料类型', '/materialtype', '16', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('21', '2', '物料管理', '物料管理', '/material', '16', 'fa fa-tag', b'0', b'1', '4', b'1', null), ('22', '2', '设备管理', '设备管理', '/device', '16', 'fa fa-tag', b'0', b'1', '5', b'1', null), ('23', '2', '车间管理', '车间管理', '/workshop', '16', 'fa fa-tag', b'0', b'1', '6', b'1', null), ('24', '2', '工序管理', '工序管理', '/process', '16', 'fa fa-tag', b'0', b'1', '7', b'1', null), ('25', '2', '产品管理', '产品管理', '/product', '16', 'fa fa-tag', b'1', b'1', '8', b'1', null), ('26', '2', '分析检验', '分析检验', '/', '0', 'fa fa-balance-scale', b'1', b'1', '0', b'1', null), ('27', '2', '物料检验录入', '物料检验录入', '/materialinspecting/YL', '26', 'fa fa-tag', b'1', b'1', '1', b'1', null), ('28', '2', '物料检验审核', '物料检验审核', '/materialinspectingcheck/YL', '26', 'fa fa-tag', b'0', b'1', '2', b'1', null), ('29', '2', '物料检验审批', '物料检验审批', '/materialinspectingapproval/YL', '26', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('30', '5', '55566', 'refdfdg', 'dfdgdfgs', '0', 'fa fa-arrows', b'1', b'1', '0', b'1', null), ('31', '2', 'grgeg', 'regvgggggg', 'rrrrrrrrr', '0', 'fa fa-audio-description', b'1', b'1', '0', b'1', null), ('32', '3', '报表分析', '报表分析', '/', '0', 'fa fa-address-card-o', b'1', b'1', '0', b'1', null), ('33', '2', '基础信息', '基础信息', '/', '0', 'fa fa-address-card', b'1', b'1', '0', b'1', null), ('34', '2', '~!@#$%   ^&*<>', '~!@#$%   ^&*<>', '~!@#$%   ^&*<>', '0', 'fa fa-adjust', b'1', b'1', '9999', b'1', null), ('35', '2', '!@3', '1112', '!@#$%^&*<>\"', '0', 'fa fa-american-sign-language-interpreting', b'1', b'1', '0', b'1', null), ('36', '2', '业务处理', '业务处理', '/business', '0', 'fa fa-audio-description', b'1', b'1', '0', b'1', null), ('37', '2', '@#$%^&<>\"', '@#$%^&<>\"', '@#$%^&<>\"', '0', 'fa fa-address-card-o', b'1', b'1', '0', b'1', null), ('38', '2', '历史数据', '历史数据', '/his', '0', 'fa fa-asterisk', b'1', b'1', '4', b'1', null), ('39', '2', '图表中心', '图表中心', '/charts', '0', 'fa fa-bar-chart', b'1', b'1', '5', b'1', null), ('40', '2', '工艺流程', '工艺流程', '/map', '0', 'fa fa-beer', b'1', b'1', '6', b'1', null), ('41', '2', '首页', '首页', '/baseindex', '16', 'fa fa-tag', b'1', b'1', '1', b'1', null), ('42', '2', '个人信息设置', '个人信息设置', '/userinfo', '16', 'fa fa-tag', b'0', b'1', '1', b'1', null), ('43', '2', '菜单管理', '菜单管理', '/menu', '16', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('44', '2', '角色管理', '角色管理', '/role', '16', 'fa fa-tag', b'0', b'1', '4', b'1', null), ('45', '2', '用户管理', '用户管理', '/user', '16', 'fa fa-tag', b'0', b'1', '5', b'1', null), ('46', '2', 'equipment', '设备管理', '/device', '16', 'fa fa-tag', b'0', b'1', '6', b'1', null), ('47', '2', '物料类型管理', '物料类型管理', '/materialtype', '16', 'fa fa-tag', b'0', b'1', '7', b'1', null), ('48', '2', '物料管理', '物料管理', '/material', '16', 'fa fa-tag', b'0', b'1', '8', b'1', null), ('49', '2', '产品管理', '产品管理', '/product', '16', 'fa fa-tag', b'0', b'1', '9', b'1', null), ('50', '2', '工序管理', '工序管理', '/process', '16', 'fa fa-tag', b'0', b'1', '9', b'1', null), ('51', '2', '车间管理', '车间管理', '/workshop', '16', 'fa fa-tag', b'0', b'1', '11', b'1', null), ('52', '2', '公用检验项管理', '公用检验项管理', '/checkitem', '16', 'fa fa-tag', b'0', b'1', '12', b'1', null), ('53', '2', '物料检验项管理', '物料检验项管理', '/materialcheckitem', '16', 'fa fa-tag', b'0', b'1', '13', b'1', null), ('54', '2', '产品检验项管理', '产品检验项管理', '/productcheckitem', '16', 'fa fa-tag', b'0', b'1', '14', b'1', null), ('55', '2', '半成品检验录入', '半成品检验录入', '/secondmaterialinspecting/BCP', '26', 'fa fa-tag', b'0', b'1', '1', b'1', null), ('56', '2', '半成品检验审核', '半成品检验审核', '/secondmaterialinspectingcheck/BCP', '26', 'fa fa-tag', b'0', b'1', '5', b'1', null), ('57', '2', '半成品检验审批', '半成品检验审批', '/secondmaterialinspectingapproval/BCP', '26', 'fa fa-tag', b'0', b'1', '6', b'1', null), ('58', '2', '成品检验录入', '成品检验录入', '/productinspecting', '26', 'fa fa-tag', b'0', b'1', '7', b'1', null), ('59', '2', '成品检验审核', '成品检验审核', '/productinspectingcheck', '26', 'fa fa-tag', b'0', b'1', '8', b'1', null), ('60', '2', '成品检验审批', '成品检验审批', '/productinspectingapproval', '26', 'fa fa-tag', b'0', b'1', '9', b'1', null), ('61', '2', '混合打包', '混合打包', '/packagebatch', '36', 'fa fa-tag', b'1', b'1', '2', b'1', null), ('62', '2', '成品发货', '成品发货', '/sendbatch', '36', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('63', '2', '生产批次汇总', '生产批次汇总', '/productbatchtotal', '38', 'fa fa-tag', b'1', b'1', '1', b'1', null), ('64', '2', '打包批次汇总', '打包批次汇总', '/packagebatchtotal', '38', 'fa fa-tag', b'0', b'1', '2', b'1', null), ('65', '2', '发货批次汇总', '发货批次汇总', '/sendbatchtotal', '38', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('66', '2', '物料检验汇总', '物料检验汇总', '/materialinspectingtotal/YL', '38', 'fa fa-tag', b'0', b'1', '4', b'1', null), ('67', '2', '半成品检验汇总', '半成品检验汇总', '/secondmaterialinspectingtotal/BCP', '38', 'fa fa-tag', b'0', b'1', '5', b'1', null), ('68', '2', '成品检验汇总', '成品检验汇总', '/productinspectingtotal', '38', 'fa fa-tag', b'0', b'1', '6', b'1', null), ('69', '2', '单设备分析', '单设备分析', '/charts2', '39', 'fa fa-tag', b'0', b'1', '1', b'1', null), ('70', '2', '多设备分析', '多设备分析', '/charts3', '39', 'fa fa-tag', b'0', b'1', '2', b'1', null), ('71', '2', '生产过程分析', '生产过程分析', '/charts4', '39', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('72', '2', '一车间', '一车间', '/map1', '40', 'fa fa-tag', b'0', b'1', '1', b'1', null), ('73', '2', '二车间', '二车间', '/map2', '40', 'fa fa-tag', b'0', b'1', '2', b'1', null), ('74', '2', '三车间', '三车间', '/map3', '40', 'fa fa-tag', b'0', b'1', '3', b'1', null), ('75', '2', '批次重量管理', '批次重量管理', '/productbatch', '36', 'fa fa-tag', b'0', b'1', '1', b'1', null), ('78', '2', '批次重量汇总', '批次重量汇总', '/productbatchinfototal', '38', 'fa fa-fire', b'1', b'1', '2', b'1', null), ('79', '2', '11', '11', '11', '0', 'fa fa-address-card', b'1', b'1', '0', b'1', null), ('80', '2', '1111', '11111', '111111', '0', 'fa fa-user-secret', b'1', b'0', '0', b'1', null), ('81', '2', '图表中心', '图表中心', '/', '0', 'fa fa-bar-chart', b'1', b'1', '0', b'1', null), ('82', '2', '963', '963', '/', '0', 'fa fa-bathtub', b'1', b'1', '0', b'1', null), ('83', '2', '+633', '655', '2222', '82', 'fa fa-cog', b'0', b'1', '0', b'1', null), ('84', '2', '图标', '图表', '图表', '81', 'fa fa-cloud', b'0', b'1', '0', b'1', null), ('85', '2', '2012', '2017', '/chart2', '81', 'fa fa-share-alt-square', b'0', b'1', '0', b'1', null), ('86', '2', '图表中心', '图表中心', '/charts', '0', 'fa fa-bar-chart', b'1', b'1', '0', b'1', null), ('87', '2', '设备分析', '设备', '/charts1', '86', 'fa fa-bank', b'1', b'1', '1', b'1', null), ('88', '2', 'reerrer', 'erwt43', '/ert443', '0', 'fa fa-share-alt-square', b'1', b'1', '0', b'1', null), ('89', '2', '系统管理', '系统管理', '/system', '0', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('90', '2', '计划管理', '计划管理', '/plan', '0', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('91', '2', '生产调度', '生产调度', '/product', '0', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('93', '2', '工艺管理', '工艺管理', '/technology', '0', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('94', '2', '实时监控', '实时监控', '/monitor', '0', 'fa fa-tag', b'1', b'1', '4', b'0', null), ('95', '2', 'adsdw', 'asdw', 'sadwad', '89', 'fa fa-address-book', b'0', b'1', '0', b'1', null), ('96', '2', '质量管理', '质量管理', '/quality', '0', 'fa fa-tag', b'1', b'1', '5', b'0', null), ('97', '2', 'HSE管理', 'HSE管理', '/hse', '0', 'fa fa-tag', b'1', b'1', '6', b'0', null), ('98', '2', '能耗管理', '能耗管理', '/energy ', '0', 'fa fa-tag', b'1', b'1', '7', b'0', null), ('99', '2', '统计分析', '统计分析', '/total', '0', 'fa fa-tag', b'1', b'1', '8', b'0', null), ('100', '2', '研发管理', '研发管理', '/research', '0', 'fa fa-tag', b'1', b'1', '9', b'0', null), ('101', '2', '组织结构管理', '组织结构管理', '/structuremanagerui', '89', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('102', '2', 'sdfwefw', 'fewfewfw', 'fewfwefewf', '89', 'fa fa-envelope', b'0', b'1', '0', b'1', null), ('103', '2', '角色权限管理', '角色权限管理', '/role', '89', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('104', '2', '基础数据管理', '基础数据管理', '/base', '89', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('105', '2', '资源数据管理', '资源数据管理', '/source', '89', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('106', '2', '计划模型配置', '计划模型配置', '/planmodel', '90', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('107', '2', '生产计划编制', '生产计划编制', '/productplan', '90', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('108', '2', '生产计划跟踪', '生产计划跟踪作业', '/plantogo', '90', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('109', '2', '工单排程', '工单排程', '/workorderplan', '91', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('110', '2', '工单执行', '工单执行', '/workordertodo', '91', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('111', '2', '作业跟踪', '作业跟踪', '/workgoto', '91', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('112', '2', '工艺规程管理', '工艺规程管理', '/techenologymanager', '93', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('113', '2', '产品配方管理', '产品配方管理', '/producttechenology', '93', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('114', '2', '工艺配方管理', '工艺配方管理', '/workordermanager', '93', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('115', '2', '工艺异常管理', '工艺异常管理', '/errortechenology', '93', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('116', '2', '流程监控', '流程监控', '/flowmonitor', '94', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('117', '2', '趋势监控', '趋势监控', '/monitorflow', '94', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('118', '2', '工艺追溯', '工艺追溯', '/workorderminitor', '94', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('119', '2', '报警监控', '报警监控', '/110monitor', '94', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('120', '2', '质量标准管理', '质量标准管理', '/qualitystarnd', '96', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('121', '2', '化验分析操作', '化验分析操作', '/madicol', '96', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('122', '2', '质量分析控制', '质量分析控制', '/qualitycontrol', '96', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('123', '2', '生产统计分析', '生产统计分析', '/totalplan', '99', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('124', '2', '质量统计分析', '质量统计分析', '/totalquality', '99', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('125', '2', '报警统计分析', '报警统计分析', '/110total', '99', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('126', '2', '组织结构定义', '组织结构定义', '/structure', '101', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('127', '2', '人员基础信息', '人员基础信息', '/user', '101', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('128', '2', '角色定义', '角色定义', '/role', '103', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('129', '2', '权限管理', '权限管理', '/rolemanager', '103', 'fa fa-tag', b'1', b'0', '1', b'0', null), ('130', '2', '计量单位', '计量单位', '/measure', '104', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('131', '2', '工厂日历', '工厂日历', '/calendar', '104', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('132', '2', '编码规则', '编码规则', '/codingrule', '104', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('133', '2', '产品基础数据', '产品基础数据', '/product', '105', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('134', '2', '物料基础数据', '物料基础数据', '/material', '105', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('135', '2', '装置基础数据', '装置基础数据', '/installation', '105', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('136', '2', '设备基础数据', '设备基础数据', '/device', '105', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('137', '2', '罐区基础数据', '罐区基础数据', '/tankfield', '105', 'fa fa-tag', b'1', b'1', '4', b'0', null), ('138', '2', '仓库基础数据', '仓库基础数据', '/warehouse', '105', 'fa fa-tag', b'1', b'1', '5', b'0', null), ('139', '2', '作业工单模板', '作业工单模板', '/tasktemplate', '106', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('140', '2', '生产计划统计', '生产计划统计', '/plantotal', '108', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('141', '2', '接受作业工单', '接受作业工单', '/taskaccept', '109', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('142', '2', '作业工单下达', '作业工单下达', '/workordernum', '109', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('143', '2', '作业工序操作', '作业工序操作', '/sortopration', '110', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('144', '2', '检验工单打印', '检验工单打印', '/检验工单打印', '110', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('145', '2', '生产批次报工', '生产批次报工', '/生产批次报工', '110', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('146', '2', '生产步序监控', '生产步序监控', '/生产步序监控', '111', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('147', '2', '作业计划跟踪', '作业计划跟踪', '/作业计划跟踪', '111', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('148', '2', '操作日志记录', '操作日志记录', '操作日志记录', '111', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('149', '2', '产品结构信息', '产品结构信息', '/productstructure', '113', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('150', '2', '产品质量指标', '产品质量指标', '/productqualityindex', '113', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('151', '2', '工序维护', '工序维护', '/process', '114', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('152', '2', '工艺路线信息', '工艺路线信息', '/processroute', '114', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('153', '2', '工艺指标信息', '工艺指标信息', '工艺指标信息', '114', 'fa fa-tag', b'1', b'0', '4', b'1', null), ('154', '2', '工艺报警定义', '工艺报警定义', '工艺报警定义', '115', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('155', '2', '工艺报警推送', '工艺报警推送', '工艺报警推送', '115', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('156', '2', '工艺流程监控', '工艺流程监控', '工艺流程监控', '116', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('157', '2', '趋势数据监控', '趋势数据监控', '趋势数据监控', '117', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('158', '2', '工艺数据追溯', '工艺数据追溯', '工艺数据追溯', '118', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('159', '2', '报警监控', '报警监控', '报警监控', '119', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('160', '2', '化验取样操作', '化验取样操作', '化验取样操作', '121', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('161', '2', '化验分析操作', '化验分析操作', '化验分析操作', '121', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('162', '2', '分析结果判定', '分析结果判定', '分析结果判定', '121', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('163', '2', '不合格处理', '不合格处理', '不合格处理', '121', 'fa fa-tag', b'1', b'1', '3', b'0', null), ('164', '2', '质量统计分析', '质量统计分析', '质量统计分析', '122', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('165', '2', '质量跟踪追溯', '质量跟踪追溯', '质量跟踪追溯', '122', 'fa fa-tag', b'1', b'1', '1', b'0', null), ('166', '2', '物料跟踪追溯', '物料跟踪追溯', '物料跟踪追溯', '122', 'fa fa-tag', b'1', b'1', '2', b'0', null), ('167', '2', '生产统计分析', '生产统计分析', '生产统计分析', '123', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('168', '2', '质量统计分析', '质量统计分析', '/totalquality', '124', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('169', '2', '报警统计分析', '报警统计分析', '/110total', '125', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('170', '1', '基础信息', '基础信息', '/', '0', 'fa fa-address-card-o', b'1', b'1', '0', b'1', null), ('171', '1', '应用管理', '应用管理', '/app', '0', 'fa fa-address-book-o', b'1', b'1', '0', b'0', null), ('172', '1', '个人信息设置', '个人信息设置', '/userinfo', '0', 'fa fa-trophy', b'1', b'1', '0', b'0', null), ('173', '1', '菜单管理', '菜单管理', '/menu', '0', 'fa fa-object-ungroup', b'1', b'1', '0', b'0', null), ('174', '1', '用户管理', '用户管理', '/user', '0', 'fa fa-bank', b'1', b'1', '0', b'0', null), ('175', '1', '角色管理', '角色管理', '/role', '0', 'fa fa-arrows', b'1', b'1', '0', b'0', null), ('176', '1', '菜单按钮管理', '菜单按钮管理', '/menuoperator', '0', 'fa fa-arrows', b'1', b'1', '0', b'0', null), ('177', '1', '角色数据权限', '角色数据权限', '/roledatarule', '0', 'fa fa-arrows', b'1', b'1', '0', b'0', null), ('178', '1', '组织结构定义', '组织结构定义', '/structure', '0', 'fa fa-arrows', b'1', b'1', '0', b'1', null), ('179', '1', '计量单位', '计量单位', '/measure', '0', 'fa fa-arrows', b'1', b'1', '0', b'1', null), ('180', '1', '编码规则', '编码规则', '/codingrule', '0', 'fa fa-arrows', b'1', b'1', '0', b'1', null), ('181', '1', '工厂日历', '工厂日历', '/calendar', '0', 'fa fa-arrows', b'1', b'1', '0', b'1', null), ('182', '1', '用户菜单管理', '用户菜单管理', '/usermenu2', '0', 'fa fa-arrows', b'1', b'1', '0', b'0', null), ('183', '1', '用户按钮权限', '用户按钮权限', '/userbuttonrule', '0', 'fa fa-arrows', b'1', b'1', '0', b'0', null), ('192', '1', 'assa', 'sasadfe', '/dafaf', '0', 'fa fa-address-book-o', b'1', b'1', '0', b'1', null), ('193', '1', '测测测', '测测测', '/ddd', '170', 'fa fa-address-book-o', b'0', b'1', '0', b'1', null), ('194', '1', '增增增', '增增增', '/index', '171', 'fa fa-address-book-o', b'0', b'1', '0', b'0', null), ('195', '2', '测试菜单', '测试菜单', '测试菜单', '101', 'fa fa-bars', b'0', b'1', '0', b'1', null), ('196', '2', '新增子菜单', '新增自菜单', '/index', '89', 'fa fa-asl-interpreting', b'0', b'1', '0', b'1', null), ('197', '2', '测试菜单2', '测试菜单', '/测试菜单', '101', 'fa fa-arrows-v', b'0', b'1', '0', b'1', null), ('198', '2', '测试菜单5', '测试菜单5', '/index', '101', 'fa fa-address-book-o', b'0', b'1', '0', b'1', null), ('199', '2', '测试菜单菜单', '测试菜单菜单', '测试菜单菜单', '89', 'fa fa-address-card', b'0', b'1', '13', b'1', null), ('200', '2', '菜单管理1', '菜单管理', '/menu', '103', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('201', '2', '数据字典', '数据字典', '/dictionary', '104', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('202', '2', '测试菜单3', '测试菜单3', '/index', '103', 'fa fa-address-card', b'1', b'1', '0', b'1', null), ('203', '2', '测试菜单111', '测试菜单111', '11111', '89', 'fa fa-address-book-o', b'0', b'1', '0', b'1', null), ('204', '2', '测试菜单333', '测试菜单333', 'ddd', '103', 'fa fa-address-card', b'0', b'1', '0', b'1', null), ('205', '2', '菜单菜单', '菜单菜单菜单菜单', 'gggg', '101', 'fa fa-address-card', b'0', b'1', '0', b'1', null), ('206', '2', '菜单管理1111', '菜单管理1111', '1111', '89', 'fa fa-address-book-o', b'0', b'1', '0', b'1', null), ('207', '3', 'ewererre', 'ererrrrre', 'ereree', '0', 'fa fa-hotel', b'1', b'1', '0', b'0', null), ('208', '2', '作业工单模型2', '作业工单模型', '/tasktemplate', '105', 'fa fa-tag', b'1', b'1', '0', b'1', null), ('209', '2', '作业工单编制', '作业工单编制', '/task', '106', 'fa fa-tag', b'0', b'1', '0', b'1', null), ('210', '2', '作业工单编制', '作业工单编制', '/task', '109', 'fa fa-tag', b'0', b'1', '1', b'0', null), ('211', '2', '今日工单执行', '今日工单执行', '/todaytask', '109', 'fa fa-tag', b'1', b'1', '0', b'0', null), ('212', '2', '物料质量指标', '物料质量指标', '/materialqualityindex', '120', 'fa fa-mortar-board', b'1', b'1', '0', b'0', null), ('213', '2', '车间管理', '车间管理', '/workshop', '101', 'fa fa-shopping-basket', b'0', b'1', '0', b'1', null), ('214', '2', '物料类型数据', '物料类型数据', '/materialtype', '105', 'fa fa-tasks', b'1', b'1', '0', b'0', null), ('215', '2', '车间基础数据', '车间基础数据', '/workshop', '105', 'fa fa-university', b'0', b'1', '0', b'0', null), ('216', '2', '物料质量指标', '物料质量指标', '/materialqualityindex', '105', 'fa fa-delicious', b'1', b'1', '0', b'1', null), ('217', '2', '产品检验项管理', '产品检验项管理', '/productcheckitem', '120', 'fa fa-paw', b'0', b'1', '0', b'1', null), ('218', '2', '物料检验数据', '物料检验数据', '/materialinspecting/YL', '121', 'fa fa-mortar-board', b'0', b'1', '0', b'1', null), ('219', '2', '单设备分析', '单设备分析', '/charts2', '123', 'fa fa-sticky-note', b'0', b'1', '0', b'0', null), ('220', '2', '多设备分析', '多设备分析', '/charts3', '123', 'fa fa-clock-o', b'0', b'1', '0', b'0', null), ('221', '2', '物料检验录入', '物料检验录入', '/materialinspecting', '120', 'fa fa-wifi', b'1', b'1', '0', b'0', null), ('222', '2', '物料检验审核', '物料检验审核', '/materialinspectingcheck', '120', 'fa fa-mortar-board', b'1', b'1', '0', b'0', null), ('223', '2', '物料检验审批', '物料检验审批', '/materialinspectingapproval', '120', 'fa fa-recycle', b'1', b'1', '0', b'0', null), ('224', '2', '(中间品/产品)检验录入', '(中间品/产品)检验录入', '/taskmaterialinspectionlist', '120', 'fa fa-bookmark', b'1', b'1', '0', b'0', null), ('225', '2', '(中间品/产品)检验审核', '(中间品/产品)检验审核', '/taskmaterialinspectiondatacheck', '120', 'fa fa-sitemap', b'1', b'1', '0', b'0', null), ('226', '2', '(中间品/产品)检验审批', '(中间品/产品)检验审批', '/taskmaterialinspectiondataapproval', '120', 'fa fa-graduation-cap', b'1', b'1', '0', b'0', null), ('227', '2', '测试444444444444444444', '测试444444444444444444', '/44444444444444444444444444444', '0', 'fa fa-battery-full', b'1', b'1', '9999', b'0', null), ('228', '2', 'cehsi ', 'ceshi ', '/role', '227', 'fa fa-video-camera', b'0', b'1', '0', b'0', null), ('229', '2', 'ceshi ', 'ceshi ', '/role', '228', 'fa fa-barcode', b'0', b'1', '0', b'0', null), ('230', '2', '编码编码编码编码编码', '编码编码编码编码编码编码编', '编码编码', '0', 'fa fa-wifi', b'1', b'1', '1', b'1', null), ('231', '2', '11111111111111111111', '11111111111111111111', '111111111111111111111111111111', '227', 'fa fa-graduation-cap', b'0', b'1', '1', b'0', null), ('232', '2', '1111', '1111', '111', '0', 'fa fa-map-marker', b'1', b'1', '11', b'1', null), ('233', '2', '工艺指标检验录入', '工艺指标检验录入', '/taskstepinspectiondatalist', '120', 'fa fa-umbrella', b'0', b'1', '0', b'0', null), ('234', '2', '工艺指标检验审核', '工艺指标检验审核', '/taskstepinspectiondatacheck', '120', 'fa fa-umbrella', b'0', b'1', '0', b'0', null), ('235', '2', '工艺指标检验审批', '工艺指标检验审批', '/taskstepinspectiondataapproval', '120', 'fa fa-umbrella', b'0', b'1', '0', b'0', null), ('236', '2', '我问问我问问无无无无无无无无无无呃呃呃日', '44444444444444444444', '44444444444444444444444444444444444444444444444444', '0', 'fa fa-calculator', b'1', b'1', '9999', b'1', null), ('237', '2', '工单明细', '工单明细', '/taskdetail', '111', 'fa fa-braille', b'0', b'1', '0', b'1', null), ('238', '2', '设备监控', '设备监控', '/workshopwatch', '94', 'fa fa-paw', b'0', b'1', '0', b'0', null), ('239', '2', '车间设备监控', '车间设备监控', '/workshopwatch', '238', 'fa fa-map-marker', b'0', b'1', '0', b'0', null), ('240', '2', '设备类型管理', '设备类型管理', '/equipmenttypelist', '105', 'fa fa-hotel', b'0', b'1', '0', b'0', null);
COMMIT;

-- ----------------------------
--  Table structure for `menuoperation`
-- ----------------------------
DROP TABLE IF EXISTS `menuoperation`;
CREATE TABLE `menuoperation` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  `Icon` varchar(50) DEFAULT NULL,
  `DeleteFlag` bit(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `menuoperation`
-- ----------------------------
BEGIN;
INSERT INTO `menuoperation` VALUES ('4', '查询', '查询', '1', null, b'0'), ('36', '添加', '添加', '193', 'fa fa-edit', b'0'), ('37', '新增', '新增', '101', 'fa fa-address-book', b'0'), ('38', '修改', '修改', '101', 'fa fa-thermometer-quarter', b'0'), ('39', '删除', '删除', '101', 'fa fa-video-camera', b'0'), ('40', '新增', '新增', '103', 'fa fa-at', b'0'), ('41', 'add', '新增', '104', 'fa fa-bar-chart-o', b'0'), ('42', 'add', '新增', '126', 'fa fa-paw', b'0');
COMMIT;

-- ----------------------------
--  Table structure for `organize`
-- ----------------------------
DROP TABLE IF EXISTS `organize`;
CREATE TABLE `organize` (
  `Id` int(11) NOT NULL,
  `AppId` int(11) DEFAULT NULL,
  `Code` varchar(20) DEFAULT NULL,
  `ParentId` varchar(20) DEFAULT NULL,
  `FullName` varchar(30) DEFAULT NULL,
  `Category` varchar(20) DEFAULT NULL,
  `OuterPhone` varchar(100) DEFAULT NULL,
  `InnerPhone` varchar(100) DEFAULT NULL,
  `Fax` varchar(20) DEFAULT NULL,
  `Postalcode` varchar(20) DEFAULT NULL,
  `Address` varchar(20) DEFAULT NULL,
  `Web` varchar(20) DEFAULT NULL,
  `Manager` varchar(20) DEFAULT NULL,
  `AssistantManager` varchar(20) DEFAULT NULL,
  `InnerOrganizeFlag` bit(1) DEFAULT NULL,
  `Sort` int(11) DEFAULT NULL,
  `Description` varchar(100) DEFAULT NULL,
  `EnableFlag` bit(1) DEFAULT NULL,
  `CreateUserID` varchar(20) DEFAULT NULL,
  `ModifyDate` datetime DEFAULT NULL,
  `AccountBook` varchar(255) DEFAULT NULL COMMENT '账套',
  `Level` int(11) DEFAULT NULL COMMENT '组织级别',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `organize`
-- ----------------------------
BEGIN;
INSERT INTO `organize` VALUES ('10000223', null, '001.02', '100000008', '办公室', 'Department', '', '', '', null, null, null, '', '', b'1', '10000460', '', b'1', 'Administrator', '2009-02-20 18:49:00', null, null), ('10000224', null, '001.02.01', '10000223', '车队', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000461', '', b'1', 'Administrator', '2009-02-20 18:49:00', null, null), ('10000243', null, '001.04', '100000008', '企业管理办公室', 'Department', '', '', '', null, null, null, '', '', b'1', '10000467', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000244', null, '001.05', '100000008', '总师办', 'Department', '', '', '', null, null, null, '', '', b'1', '10000470', '', b'1', 'dd', '2009-08-27 12:26:00', null, null), ('10000245', null, '001.06', '100000008', '财务部', 'Department', '', '', '', null, null, null, '', '', b'1', '10000474', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000246', null, '001.04.01', '10000243', '考核科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000468', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000247', null, '001.04.02', '10000243', '业务监管中心', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000469', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000248', null, '001.05.01', '10000244', '中心化验室', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000471', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000249', null, '001.05.02', '10000244', '计算机中心', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000472', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000250', null, '001.05.03', '10000244', '机电管理科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000473', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000251', null, '001.07', '100000008', '营业所', 'Department', '', '', '', null, null, null, '', '', b'1', '10000475', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000252', null, '001.07.01', '10000251', '营销服务中心', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000476', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000253', null, '001.07.02', '10000251', '应急抢修科（零星施工队）', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000477', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000254', null, '001.08', '100000008', '管线所', 'Department', '', '', '', null, null, null, '', '', b'1', '10000478', '', b'1', 'dd', '2009-02-20 18:50:00', null, null), ('10000255', null, '001.08.01', '10000254', '供水管理科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000479', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000256', null, '001.08.02', '10000254', '管网维护科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000480', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000257', null, '001.08.03', '10000254', '供水稽查科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000481', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000258', null, '001.09', '100000008', '材料部', 'Department', '', '', '', null, null, null, '', '', b'1', '10000482', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000260', null, '001.03', '100000008', '工程部', 'Department', '', '', '', null, null, null, '', '', b'1', '10000463', '', b'1', 'dd', '2009-02-20 18:49:00', null, null), ('10000261', null, '001.03.02', '10000260', '工程管理科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000465', '', b'1', 'dd', '2009-09-05 22:49:00', null, null), ('10000262', null, '001.01', '100000008', '领导班子', 'Department', '', '', '', null, null, null, '', '', b'1', '10000459', '', b'1', 'Administrator', '2009-08-20 10:40:00', null, null), ('10000263', null, '001.03.03', '10000260', '工程技术科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000466', '', b'1', 'dd', '2009-09-05 22:49:00', null, null), ('10000264', null, '001.03.01', '10000260', '工程监理科', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000464', '', b'1', 'dd', '2009-09-05 22:49:00', null, null), ('10000266', null, '001.10', '100000008', '太湖源水厂', 'Department', '', '', '', null, null, null, '', '', b'1', '10000485', '', b'1', 'dd', '2009-02-20 18:52:00', null, null), ('10000267', null, '001.10.02', '10000266', '生产班组朱', 'SubCompany', '', '', '', null, null, null, '', '', b'1', '10000487', '', b'1', 'dd', '2009-08-20 19:51:00', null, null), ('10000268', null, '001.10.01', '10000266', '综合科', 'SubCompany', '', '', '', null, null, null, '', '', b'1', '10000486', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000269', null, '001.11', '100000008', '高虹水厂', 'Department', '', '', '', null, null, null, '', '', b'1', '10000491', '', b'1', 'dd', '2009-02-20 18:51:00', null, null), ('10000270', null, '001.12', '100000008', '青山水厂', 'Department', '', '', '', null, null, null, '', '', b'1', '10000492', '', b'1', 'dd', '2009-08-20 19:51:00', null, null), ('10000271', null, '001.09.01', '10000258', '水表计量检定', 'SubDepartment', '', '', '', null, null, null, '', '', b'1', '10000483', '', b'1', 'Administrator', '2009-02-20 18:51:00', null, null), ('10000272', null, '002.01', '10000310', '东蓝数码', 'Company', '', '', '', null, null, null, '', '', b'0', '10000494', '', b'1', 'Administrator', '2009-02-20 18:52:00', null, null), ('10000273', null, '002.01.01', '10000272', '浙江东蓝科技', 'Department', '', '', '', null, null, null, '', '', b'0', '10000495', '', b'1', 'Administrator', '2009-02-20 18:52:00', null, null), ('10000310', null, '002', '', '合作伙伴', 'Company', '', '', '', null, null, null, '', '', b'0', '10000493', '', b'1', '10000162', '2009-08-27 20:06:00', null, null), ('10000312', null, '002.02', '10000310', '杭州富阳威尔特塑胶有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000496', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000313', null, '002.03', '10000310', '金洲管道科技股份有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000497', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000314', null, '002.04', '10000310', '浙江桐庐伐门总厂', null, null, null, null, null, null, null, null, null, b'0', '10000498', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000315', null, '002.05', '10000310', '奉化溪口明山管道配件经营部', null, null, null, null, null, null, null, null, null, b'0', '10000499', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000316', null, '002.06', '10000310', '圣戈班铸管有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000500', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000317', null, '002.07', '10000310', '临海市伟星新型建材有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000501', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000318', null, '002.08', '10000310', '杭州市江干区清源水暖五金商店', null, null, null, null, null, null, null, null, null, b'0', '10000502', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000319', null, '002.09', '10000310', '杭州萧山市北管件铸造厂', null, null, null, null, null, null, null, null, null, b'0', '10000503', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000320', null, '002.10', '10000310', '杭州金盟道路设施有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000504', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000321', null, '002.11', '10000310', '杭州顺达塑胶公司', null, null, null, null, null, null, null, null, null, b'0', '10000505', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000322', null, '002.12', '10000310', '杭州巨大工业品公司', null, null, null, null, null, null, null, null, null, b'0', '10000506', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000323', null, '002.13', '10000310', '杭州通泰建筑材料有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000507', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000324', null, '002.14', '10000310', '杭州水表有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000508', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000325', null, '002.15', '10000310', '杭州亚大工业品公司', null, null, null, null, null, null, null, null, null, b'0', '10000509', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000326', null, '002.16', '10000310', '临安永兴综合商店', null, null, null, null, null, null, null, null, null, b'0', '10000510', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000327', null, '002.17', '10000310', '杭州临安电器开关厂', null, null, null, null, null, null, null, null, null, b'0', '10000511', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000328', null, '002.18', '10000310', '杭州临安星光物资有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000512', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000329', null, '002.19', '10000310', '杭州永通建材有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000513', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000330', null, '002.20', '10000310', '杨岭水泥厂', null, null, null, null, null, null, null, null, null, b'0', '10000514', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000331', null, '002.21', '10000310', '上甘水泥厂', null, null, null, null, null, null, null, null, null, b'0', '10000515', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000332', null, '002.22', '10000310', '杭州山科电子技术开发有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000516', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000333', null, '002.23', '10000310', '临安家用五交化批发部', null, null, null, null, null, null, null, null, null, b'0', '10000517', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000334', null, '002.24', '10000310', '临安螺丝商店', null, null, null, null, null, null, null, null, null, b'0', '10000518', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000335', null, '002.25', '10000310', '杭州宏发建材有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000519', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000336', null, '002.26', '10000310', '临安砖瓦厂', null, null, null, null, null, null, null, null, null, b'0', '10000520', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000337', null, '002.27', '10000310', '临安临天砖瓦厂', null, null, null, null, null, null, null, null, null, b'0', '10000521', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000338', null, '002.28', '10000310', '临安市城南文体用品商店', null, null, null, null, null, null, null, null, null, b'0', '10000522', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000339', null, '002.29', '10000310', '临安油漆商店', null, null, null, null, null, null, null, null, null, b'0', '10000523', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000340', null, '002.30', '10000310', '浙江双羊集团有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000524', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000341', null, '002.31', '10000310', '临安巨丰城市配套设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000525', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000342', null, '002.32', '10000310', '奉化市溪口明山管道配件经营部', null, null, null, null, null, null, null, null, null, b'0', '10000526', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000343', null, '002.33', '10000310', '宁波水表股份有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000527', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000344', null, '002.34', '10000310', '杭州长城机电市场鑫鑫电器商行', null, null, null, null, null, null, null, null, null, b'0', '10000528', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000345', null, '002.35', '10000310', '临安市新联文教用品批发部', null, null, null, null, null, null, null, null, null, b'0', '10000529', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000346', null, '002.36', '10000310', '杭州欣达钢塑复合管有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000530', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000347', null, '002.37', '10000310', '乐清市宏达消防器材厂', null, null, null, null, null, null, null, null, null, b'0', '10000531', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000348', null, '002.38', '10000310', '金华市巨龙管业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000532', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000349', null, '002.39', '10000310', '临安锦城镇上引五金商店', null, null, null, null, null, null, null, null, null, b'0', '10000533', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000350', null, '002.40', '10000310', '铜陵市铜都给排水设备制造有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000534', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000351', null, '002.41', '10000310', '临安长城电器销售部', null, null, null, null, null, null, null, null, null, b'0', '10000535', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000352', null, '002.42', '10000310', '杭州帝盟电子商行', null, null, null, null, null, null, null, null, null, b'0', '10000536', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000353', null, '002.43', '10000310', '临安钱王轴承供应处', null, null, null, null, null, null, null, null, null, b'0', '10000537', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000354', null, '002.44', '10000310', '临安信禾钢构有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000538', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000355', null, '002.45', '10000310', '中国江苏金羊集团公司', null, null, null, null, null, null, null, null, null, b'0', '10000539', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000356', null, '002.46', '10000310', '临安市小强水电建材经营部', null, null, null, null, null, null, null, null, null, b'0', '10000540', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000357', null, '002.47', '10000310', '浙江兰溪力特堵漏王有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000541', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000358', null, '002.48', '10000310', '马鞍山宏力橡胶制品有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000542', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000359', null, '002.49', '10000310', '宁波一机阀门制造有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000543', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000360', null, '002.50', '10000310', '临安华通锅炉水暖配件经营部', null, null, null, null, null, null, null, null, null, b'0', '10000544', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000361', null, '002.51', '10000310', '临安正泰机电有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000545', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000362', null, '002.52', '10000310', '杭州亚光机电贸易商行', null, null, null, null, null, null, null, null, null, b'0', '10000546', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000363', null, '002.53', '10000310', '华东医药股份有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000547', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000364', null, '002.54', '10000310', '杭州申宏贸易有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000548', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000365', null, '002.55', '10000310', '四川省川力泵阀制造有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000549', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000366', null, '002.56', '10000310', '宁波市海曙东渡凌云电子科技商行', null, null, null, null, null, null, null, null, null, b'0', '10000550', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000367', null, '002.57', '10000310', '浙江东方豪博管业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000551', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000368', null, '002.58', '10000310', '徐州光大新兴铸管有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000552', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000369', null, '002.59', '10000310', '临安东盛机电设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000553', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000370', null, '002.60', '10000310', '临安万能螺丝商店', null, null, null, null, null, null, null, null, null, b'0', '10000554', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000371', null, '002.61', '10000310', '杭州贝斯特机电设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000555', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000372', null, '002.62', '10000310', '临安明天建材有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000556', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000373', null, '002.63', '10000310', '临安康居建筑配套工程有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000557', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000374', null, '002.64', '10000310', '杭州春江阀门有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000558', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000375', null, '002.65', '10000310', '铜陵市佳诚机械有限责任公司', null, null, null, null, null, null, null, null, null, b'0', '10000559', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000376', null, '002.66', '10000310', '宁波市镇海明泰设备成套厂', null, null, null, null, null, null, null, null, null, b'0', '10000560', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000377', null, '002.67', '10000310', '临安气体有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000561', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000378', null, '002.68', '10000310', '台州市碧泉管业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000562', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000379', null, '002.69', '10000310', '临安青山五金电器商店', null, null, null, null, null, null, null, null, null, b'0', '10000563', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000380', null, '002.70', '10000310', '浙江临安华石化工有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000564', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000381', null, '002.71', '10000310', '新兴铸管股份有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000565', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000382', null, '002.72', '10000310', '成都川力达泵阀科贸有限责任公司', null, null, null, null, null, null, null, null, null, b'0', '10000566', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000383', null, '002.73', '10000310', '杭州临安天力机械有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000567', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000384', null, '002.74', '10000310', '南京理工水夫环保科技有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000568', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000385', null, '002.75', '10000310', '安徽同发设备股份有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000569', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000386', null, '002.76', '10000310', '铜陵长通阀门管道有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000570', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000387', null, '002.77', '10000310', '青山镇石亭子水泥砖制品厂', null, null, null, null, null, null, null, null, null, b'0', '10000571', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000388', null, '002.78', '10000310', '临安市永兴水电五金商店', null, null, null, null, null, null, null, null, null, b'0', '10000572', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000389', null, '002.79', '10000310', '临安锦城水电安装队门市部', null, null, null, null, null, null, null, null, null, b'0', '10000573', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000390', null, '002.80', '10000310', '浙江金洲管道工业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000574', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000391', null, '002.81', '10000310', '永康市高尚校具有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000575', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000392', null, '002.82', '10000310', '杭州宏伟金属管道厂', null, null, null, null, null, null, null, null, null, b'0', '10000576', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000393', null, '002.83', '10000310', '杭州临安四通管业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000577', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000394', null, '002.84', '10000310', '桐乡市石门鸣人水暖器材厂', null, null, null, null, null, null, null, null, null, b'0', '10000578', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000395', null, '002.85', '10000310', '杭州天健流体控制设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000579', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000396', null, '002.86', '10000310', '上海连城集团有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000580', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000397', null, '002.87', '10000310', '杭州固工建材商行', null, null, null, null, null, null, null, null, null, b'0', '10000581', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000398', null, '002.88', '10000310', '临安万基商品混泥土有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000582', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000399', null, '002.89', '10000310', '杭州南方机电市场承龙机电经营部', null, null, null, null, null, null, null, null, null, b'0', '10000583', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000400', null, '002.90', '10000310', '杭州恒大建筑设备成套有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000584', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000401', null, '002.91', '10000310', '杭州五星管道有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000585', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000402', null, '002.92', '10000310', '临安市五交化商店', null, null, null, null, null, null, null, null, null, b'0', '10000586', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000403', null, '002.93', '10000310', '张家港市丰昌防腐材料有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000587', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000404', null, '002.94', '10000310', '浙江尤尼克管业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000588', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000405', null, '002.95', '10000310', '杭州派士管材有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000589', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000406', null, '002.96', '10000310', '张家港市金昌化工有限责任公司', null, null, null, null, null, null, null, null, null, b'0', '10000590', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000407', null, '002.97', '10000310', '临安市金马农业机械有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000591', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000408', null, '002.98', '10000310', '青岛三利中德美水设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000592', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000409', null, '002.99', '10000310', '杭州临安耐特电气有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000593', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000410', null, '002.100', '10000310', '杭州中肯机电设备有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000594', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000411', null, '002.101', '10000310', '上海连成(集团)杭州分公司', null, null, null, null, null, null, null, null, null, b'0', '10000595', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000412', null, '002.102', '10000310', '杭州南方浙金机电有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000596', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000413', null, '002.103', '10000310', '临安天胜机械厂', null, null, null, null, null, null, null, null, null, b'0', '10000597', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000414', null, '002.104', '10000310', '临安市植物医院', null, null, null, null, null, null, null, null, null, b'0', '10000598', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000415', null, '002.105', '10000310', '临安非凡机械厂', null, null, null, null, null, null, null, null, null, b'0', '10000599', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000416', null, '002.106', '10000310', '临安警安消防交通设施商行', null, null, null, null, null, null, null, null, null, b'0', '10000600', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000417', null, '002.107', '10000310', '临安市天盛农机商行', null, null, null, null, null, null, null, null, null, b'0', '10000601', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000418', null, '002.108', '10000310', '旺旺白铁店', null, null, null, null, null, null, null, null, null, b'0', '10000602', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000419', null, '002.109', '10000310', '杭州戈林海科技有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000603', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000420', null, '002.110', '10000310', '临安天马塑胶商行', null, null, null, null, null, null, null, null, null, b'0', '10000604', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000421', null, '002.111', '10000310', '杭州通炬机电自动化工程有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000605', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000422', null, '002.112', '10000310', '临安同信机械厂', null, null, null, null, null, null, null, null, null, b'0', '10000606', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000423', null, '002.113', '10000310', '临安锦明物资有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000607', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000424', null, '002.114', '10000310', '临安市商业个体工商户水科鑫', null, null, null, null, null, null, null, null, null, b'0', '10000608', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000425', null, '002.115', '10000310', '杭州飞华环保器材厂', null, null, null, null, null, null, null, null, null, b'0', '10000609', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000426', null, '002.116', '10000310', '青山湖街道骆琴建筑材料加工厂', null, null, null, null, null, null, null, null, null, b'0', '10000610', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000427', null, '002.117', '10000310', '青山水厂仓库多余材料暂估入帐', null, null, null, null, null, null, null, null, null, b'0', '10000611', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000428', null, '002.118', '10000310', '仓库多余材料', null, null, null, null, null, null, null, null, null, b'0', '10000612', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000429', null, '002.119', '10000310', '筑境退回材料', null, null, null, null, null, null, null, null, null, b'0', '10000613', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000430', null, '002.120', '10000310', '拆回管', null, null, null, null, null, null, null, null, null, b'0', '10000614', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000431', null, '002.121', '10000310', '二水厂仓库拉来', null, null, null, null, null, null, null, null, null, b'0', '10000615', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000432', null, '002.122', '10000310', '杭州西子泵业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000616', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000433', null, '002.123', '10000310', '无缝钢管涂防腐附属材料', null, null, null, null, null, null, null, null, null, b'0', '10000617', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000434', null, '002.124', '10000310', '四川川力智能阀业有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000618', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000435', null, '002.125', '10000310', '临安市海盛机械厂', null, null, null, null, null, null, null, null, null, b'0', '10000619', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000436', null, '002.126', '10000310', '临安东杭金属管件厂', null, null, null, null, null, null, null, null, null, b'0', '10000620', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000437', null, '002.127', '10000310', '临安市钱鑫水电工程有限公司', null, null, null, null, null, null, null, null, null, b'0', '10000621', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000438', null, '002.128', '10000310', '马鞍山市春光橡胶制品厂', null, null, null, null, null, null, null, null, null, b'0', '10000622', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000439', null, '002.129', '10000310', '杭州南方机电市场明兴水暖经营部', null, null, null, null, null, null, null, null, null, b'0', '10000623', null, b'1', '10000162', '2009-08-11 12:54:00', null, null), ('10000451', null, '001.02.02', '10000223', '后勤服务', 'SubDepartment', null, null, null, null, null, null, null, null, b'1', '10000462', null, b'1', '10000165', null, null, null), ('10000452', null, '001.09.02', '10000258', '仓库', 'SubDepartment', null, null, null, null, null, null, null, null, b'1', '10000484', null, b'1', '10000165', null, null, null), ('10000453', null, '001.10.03', '10000266', '生产班组何', 'SubDepartment', null, null, null, null, null, null, null, null, b'1', '10000488', null, b'1', '10000165', null, null, null), ('10000454', null, '001.10.04', '10000266', '生产班组吴', 'SubDepartment', null, null, null, null, null, null, null, null, b'1', '10000489', null, b'1', '10000165', null, null, null), ('10000455', null, '001.10.05', '10000266', '生产班组童', 'SubDepartment', null, null, null, null, null, null, null, null, b'1', '10000490', null, b'1', '10000165', null, null, null), ('100000008', null, '001', null, '市自来水有限公司', 'Company', '', '', '', null, null, null, '', '', b'1', '10000458', '', b'1', 'Administrator', '2009-02-20 18:49:00', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `DeleteFlag` bit(1) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModifyDate` datetime DEFAULT NULL,
  `AppId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', '管理员', 'ipmes管理员', b'0', '2017-03-14 16:29:59', '2017-06-30 16:20:11', '2'), ('2', 'admin', 'xtp管理员', b'0', '2017-06-02 08:25:50', '2017-06-07 13:40:22', '1'), ('27', 'test', '测试人员', b'0', '2017-06-05 17:23:25', '2017-06-07 13:40:11', '1'), ('28', 'diaodu001', '调度员', b'0', '2017-06-16 11:30:58', '2017-06-27 18:25:57', '2'), ('29', '^&<>^&\"\"', '^&<>^&\"\"', b'1', '2017-06-16 11:32:03', '2017-06-19 11:22:53', '2'), ('30', '1233', '调度员2', b'1', '2017-06-16 11:33:43', '2017-06-19 11:22:51', '2'), ('31', 'caozu001', '操作员', b'1', '2017-06-19 18:43:46', '2017-06-27 18:27:53', '2'), ('32', '%^&*<>\"\"\'\'', '%^&*<>\"\"\'\'', b'1', '2017-06-19 18:44:42', '2017-06-27 14:27:02', '2'), ('33', 'TYU', 'TYU', b'1', '2017-06-19 18:45:09', '2017-06-19 18:45:16', '2'), ('34', '0201001', '计划员', b'1', '2017-06-27 20:46:19', '2017-06-27 21:23:25', '2');
COMMIT;

-- ----------------------------
--  Table structure for `roledatarule`
-- ----------------------------
DROP TABLE IF EXISTS `roledatarule`;
CREATE TABLE `roledatarule` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `RoleId` int(11) NOT NULL COMMENT '角色',
  `Value` varchar(50) NOT NULL COMMENT 'sql条件值',
  `CreateDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `Symbol` varchar(255) DEFAULT NULL COMMENT '符号',
  `MenuId` int(11) DEFAULT NULL COMMENT '菜单',
  `FieldName` varchar(50) DEFAULT NULL COMMENT '字段名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色数据规则';

-- ----------------------------
--  Records of `roledatarule`
-- ----------------------------
BEGIN;
INSERT INTO `roledatarule` VALUES ('40', '1', '6', '2016-12-21 23:05:14', '>=', '17', '呜呜呜呜'), ('41', '1', '4', '2016-12-21 23:05:14', '<=', '17', '恩恩'), ('42', '1', '5', '2016-12-21 23:05:14', null, '17', null), ('43', '1', '3', '2016-12-21 23:05:14', null, '17', null), ('44', '2', '6', '2016-12-21 23:05:22', null, null, null), ('45', '2', '4', '2016-12-21 23:05:22', null, null, null), ('46', '3', '2', '2016-12-21 23:05:22', 'like', '46', 'EquipmentName'), ('47', '1', '2', null, '>', '1', '权限1'), ('48', '1', '7', null, '>', '16', '测试权限'), ('49', '1', '8', null, '>=', '16', '测试权限'), ('50', '1', '6', null, '>', '16', '测试权限'), ('51', '1', '6', null, '>', '16', '测试权限'), ('52', '1', '6', null, '>', '16', '测试权限'), ('53', '1', '6', null, '>', '16', '测试权限'), ('54', '1', '6', null, '>', '16', '测试权限'), ('55', '1', '6', null, '>', '16', '测试权限'), ('56', '1', '6', null, '>', '16', '测试权限'), ('57', '1', '6', null, '>', '16', '测试权限'), ('68', '1', '1.7', null, '<', '41', '测试菜单2更新'), ('69', '1', '2', null, '<', '41', '菜单测试3'), ('70', '1', '3', null, '<', '42', '测试4'), ('71', '1', '6', null, '==', '42', '测试啦'), ('73', '3', '1', null, '<=', '1', '测试啊'), ('74', '1', '3', null, '==', '43', '测试菜单权限'), ('75', '3', '4', null, '<', '41', '加工资权限'), ('76', '3', '3', null, '>=', '41', '减工资权限'), ('77', '3', '6', null, '>=', '74', 'flower(花儿权限)'), ('78', '3', '25', null, '>=', '74', '护花使者'), ('79', '1', '222', null, '>', '89', '23123212222'), ('81', '1', '1111', null, '>', '101', '万千瓦'), ('82', '1', '222', null, '>', '101', '222'), ('83', '1', '333', null, '>', '101', '333'), ('84', '1', '444', null, '>=', '106', '222'), ('85', '1', '333', null, '<=', '90', '333'), ('86', '1', '666', null, '>=', '106', '666'), ('87', '1', '6666', null, '>', '3058', '6666'), ('88', '2', '222', null, '>', '193', '111'), ('89', '2', '1111ddd', null, '==', '171', '111'), ('90', '1', '1', null, '>', '89', '2'), ('91', '1', '\'admin\'', null, '=', '3200', 'name');
COMMIT;

-- ----------------------------
--  Table structure for `rolemenu`
-- ----------------------------
DROP TABLE IF EXISTS `rolemenu`;
CREATE TABLE `rolemenu` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `RoleId` int(11) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5011 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `rolemenu`
-- ----------------------------
BEGIN;
INSERT INTO `rolemenu` VALUES ('3267', '2', '194'), ('3268', '2', '171'), ('3269', '2', '171'), ('3270', '2', '172'), ('3271', '2', '173'), ('3272', '2', '174'), ('3273', '2', '175'), ('3274', '2', '176'), ('3275', '2', '177'), ('3276', '2', '182'), ('3277', '2', '183'), ('4545', '34', '89'), ('4546', '34', '101'), ('4547', '34', '103'), ('4548', '34', '104'), ('4549', '34', '105'), ('4550', '34', '126'), ('4551', '34', '127'), ('4552', '34', '128'), ('4553', '34', '129'), ('4554', '34', '130'), ('4555', '34', '131'), ('4556', '34', '132'), ('4557', '34', '133'), ('4558', '34', '134'), ('4559', '34', '135'), ('4560', '34', '136'), ('4561', '34', '137'), ('4562', '34', '138'), ('4563', '34', '200'), ('4564', '34', '201'), ('4565', '34', '214'), ('4566', '34', '215'), ('4567', '34', '90'), ('4568', '34', '106'), ('4569', '34', '107'), ('4570', '34', '108'), ('4571', '34', '139'), ('4572', '34', '140'), ('4573', '34', '91'), ('4574', '34', '109'), ('4575', '34', '110'), ('4576', '34', '111'), ('4577', '34', '141'), ('4578', '34', '142'), ('4579', '34', '143'), ('4580', '34', '144'), ('4581', '34', '145'), ('4582', '34', '146'), ('4583', '34', '147'), ('4584', '34', '148'), ('4585', '34', '210'), ('4586', '34', '211'), ('4587', '34', '93'), ('4588', '34', '112'), ('4589', '34', '113'), ('4590', '34', '114'), ('4591', '34', '115'), ('4592', '34', '149'), ('4593', '34', '150'), ('4594', '34', '151'), ('4595', '34', '152'), ('4596', '34', '154'), ('4597', '34', '155'), ('4598', '34', '94'), ('4599', '34', '116'), ('4600', '34', '117'), ('4601', '34', '118'), ('4602', '34', '119'), ('4603', '34', '156'), ('4604', '34', '157'), ('4605', '34', '158'), ('4606', '34', '159'), ('4607', '34', '96'), ('4608', '34', '120'), ('4609', '34', '121'), ('4610', '34', '122'), ('4611', '34', '160'), ('4612', '34', '161'), ('4613', '34', '162'), ('4614', '34', '163'), ('4615', '34', '164'), ('4616', '34', '165'), ('4617', '34', '166'), ('4618', '34', '212'), ('4619', '34', '221'), ('4620', '34', '222'), ('4621', '34', '223'), ('4622', '34', '224'), ('4623', '34', '225'), ('4624', '34', '226'), ('4625', '34', '97'), ('4626', '34', '98'), ('4627', '34', '99'), ('4628', '34', '123'), ('4629', '34', '124'), ('4630', '34', '125'), ('4631', '34', '167'), ('4632', '34', '168'), ('4633', '34', '169'), ('4634', '34', '219'), ('4635', '34', '220'), ('4636', '34', '100'), ('4916', '1', '89'), ('4917', '1', '101'), ('4918', '1', '103'), ('4919', '1', '104'), ('4920', '1', '105'), ('4921', '1', '126'), ('4922', '1', '127'), ('4923', '1', '128'), ('4924', '1', '129'), ('4925', '1', '130'), ('4926', '1', '131'), ('4927', '1', '132'), ('4928', '1', '133'), ('4929', '1', '134'), ('4930', '1', '135'), ('4931', '1', '136'), ('4932', '1', '137'), ('4933', '1', '138'), ('4934', '1', '200'), ('4935', '1', '201'), ('4936', '1', '214'), ('4937', '1', '215'), ('4938', '1', '240'), ('4939', '1', '90'), ('4940', '1', '106'), ('4941', '1', '107'), ('4942', '1', '108'), ('4943', '1', '139'), ('4944', '1', '140'), ('4945', '1', '91'), ('4946', '1', '109'), ('4947', '1', '110'), ('4948', '1', '111'), ('4949', '1', '141'), ('4950', '1', '142'), ('4951', '1', '143'), ('4952', '1', '144'), ('4953', '1', '145'), ('4954', '1', '146'), ('4955', '1', '147'), ('4956', '1', '148'), ('4957', '1', '210'), ('4958', '1', '211'), ('4959', '1', '93'), ('4960', '1', '112'), ('4961', '1', '113'), ('4962', '1', '114'), ('4963', '1', '115'), ('4964', '1', '149'), ('4965', '1', '150'), ('4966', '1', '151'), ('4967', '1', '152'), ('4968', '1', '154'), ('4969', '1', '155'), ('4970', '1', '94'), ('4971', '1', '116'), ('4972', '1', '117'), ('4973', '1', '118'), ('4974', '1', '119'), ('4975', '1', '156'), ('4976', '1', '157'), ('4977', '1', '158'), ('4978', '1', '159'), ('4979', '1', '238'), ('4980', '1', '239'), ('4981', '1', '96'), ('4982', '1', '120'), ('4983', '1', '121'), ('4984', '1', '122'), ('4985', '1', '160'), ('4986', '1', '161'), ('4987', '1', '162'), ('4988', '1', '163'), ('4989', '1', '164'), ('4990', '1', '165'), ('4991', '1', '166'), ('4992', '1', '212'), ('4993', '1', '221'), ('4994', '1', '222'), ('4995', '1', '223'), ('4996', '1', '224'), ('4997', '1', '225'), ('4998', '1', '226'), ('4999', '1', '233'), ('5000', '1', '234'), ('5001', '1', '235'), ('5002', '1', '99'), ('5003', '1', '123'), ('5004', '1', '124'), ('5005', '1', '125'), ('5006', '1', '167'), ('5007', '1', '168'), ('5008', '1', '169'), ('5009', '1', '219'), ('5010', '1', '220');
COMMIT;

-- ----------------------------
--  Table structure for `rolemenuoperation`
-- ----------------------------
DROP TABLE IF EXISTS `rolemenuoperation`;
CREATE TABLE `rolemenuoperation` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `RoleId` int(11) DEFAULT NULL,
  `MenuOperationId` int(11) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `rolemenuoperation`
-- ----------------------------
BEGIN;
INSERT INTO `rolemenuoperation` VALUES ('1', '3', '1', '4', 'add'), ('2', '3', '2', '4', 'edit'), ('3', '1', '3', null, 'del'), ('4', '1', '1', '89', null), ('5', '1', '1', '89', null), ('6', null, '35', '89', null), ('7', '1', '1', '101', null), ('8', '1', '2', '101', null), ('9', '1', '2', '89', null), ('10', '1', '2', '89', null), ('11', '1', '2', '89', null), ('13', null, '4', '101', null), ('14', null, '3', '101', null), ('17', '1', '3', '101', null), ('18', '1', '34', '89', null), ('19', '1', '35', '89', null), ('20', '1', '1', '106', null), ('21', '1', '1', '105', null), ('22', '1', '3', '105', null), ('23', '1', '3', '104', null), ('24', '1', '1', '104', null), ('25', '1', '3', '89', null), ('26', '1', '1', '3058', null), ('27', '1', '35', '3058', null), ('28', '1', '2', '3058', null), ('29', '1', '1', '90', null), ('32', '1', '3', '90', null), ('33', '2', '1', '171', null), ('34', '1', '4', '3198', null), ('35', '1', '37', '101', null), ('36', '1', '39', '101', null);
COMMIT;

-- ----------------------------
--  Table structure for `roleuser`
-- ----------------------------
DROP TABLE IF EXISTS `roleuser`;
CREATE TABLE `roleuser` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `roleId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `roleuser`
-- ----------------------------
BEGIN;
INSERT INTO `roleuser` VALUES ('1', '1', '1'), ('33', '2', '2'), ('56', '99', '31'), ('59', '101', '1'), ('60', '101', '28'), ('67', '100', '1'), ('68', '100', '34'), ('69', '39', '1');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `AppUserId` int(11) DEFAULT NULL COMMENT '在具体应用User表中的Id',
  `AppId` int(11) DEFAULT NULL,
  `OrganizeId` int(11) DEFAULT NULL,
  `OrganizeIdName` varchar(50) DEFAULT NULL,
  `Account` varchar(50) DEFAULT NULL,
  `Password` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Mail` varchar(50) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `QQ` varchar(50) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `ModifyDate` datetime DEFAULT NULL,
  `DeleteFlag` bit(1) DEFAULT NULL,
  `groupId` int(11) DEFAULT NULL,
  `Birth` date DEFAULT NULL COMMENT '出生年月',
  `EducationId` int(11) DEFAULT NULL COMMENT '学历',
  `DepartmentId` int(11) DEFAULT NULL COMMENT '所属部门ID',
  `PostId` int(11) DEFAULT NULL COMMENT '所属岗位ID',
  `Quality` varchar(50) DEFAULT NULL COMMENT '资质',
  `WorkTypeId` int(11) DEFAULT NULL COMMENT '工种ID',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8199 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', '39', '2', '38816', null, 'admin', 'admin', '管理员', '58896874@qq.com', '13634198185', '74125896', '2017-03-23 11:43:36', '2017-06-30 16:20:04', b'0', '38816', '2017-06-06', '1', '1', '1', '资质', '1'), ('2', '2', '1', '38816', null, 'myadmin', 'admin', '柠檬树', '8888888888@163.com', '18865487965', '88888888', '2017-06-07 13:35:23', '2017-06-08 17:32:08', b'0', null, null, null, null, null, null, null), ('8131', '8131', '1', null, null, 'oper', null, '操作人员', '', '13333333333', '', '2017-06-05 17:47:45', '2017-06-07 13:27:12', b'0', null, null, null, null, null, null, null), ('8132', '8132', '1', null, null, '而我却二无群', '32tpizps', '其味无穷二', '3321@qq.com', '18868596478', '45465', '2017-06-08 17:55:22', '2017-06-08 17:54:38', b'0', null, null, null, null, null, null, null), ('8133', '8133', '2', '0', null, 'suiyu', '', '碎雨', '645874563@qq.com', '15689547894', '6325468', '2017-06-09 13:37:23', '2017-06-09 13:37:24', b'0', null, null, null, null, null, null, null), ('8134', '8134', '2', '0', null, 'suiyu', '7mztq3jk', '碎雨', '645874563@qq.com', '15689547894', '6325468', '2017-06-09 13:37:23', '2017-06-09 13:49:00', b'0', null, null, null, null, null, null, null), ('8135', '8135', '2', '0', null, 'suiyu', '7mztq3jk', '碎雨', '645874563@qq.com', '15689547894', '6325468', '2017-06-09 13:37:23', '2017-06-09 13:50:11', b'0', null, null, null, null, null, null, null), ('8136', '8136', '2', '0', null, null, 'rgpug8vm', null, null, null, null, null, '2017-06-15 14:50:37', null, null, null, null, null, null, null, null), ('8137', '8137', '2', '0', null, 'suiyu', 'rgpug8vm', '碎雨', '645874563@qq.com', '15689547894', '6325468', '2017-06-09 13:37:23', '2017-06-15 14:51:26', b'0', null, null, null, null, null, null, null), ('8138', '8138', '2', '0', null, '22222222222222222222', '', '22222222222222222222', '', '15625648956', '4148555', '2017-06-16 11:07:02', '2017-06-16 11:07:03', b'0', null, null, null, null, null, null, null), ('8139', '8139', '2', '0', null, null, 'kvgw58ra', null, null, null, null, null, '2017-06-16 11:07:33', null, null, null, null, null, null, null, null), ('8140', '8140', '2', '0', null, '22222222222222222222', 'p3hltaww', '22222222222222222222', '', '15625648956', '4148555', '2017-06-16 11:07:02', '2017-06-16 11:08:27', b'0', null, null, null, null, null, null, null), ('8141', '8141', '2', '0', null, '22222222222222222222', 'p3hltaww', '22222222222222222222', '', '15625648956', '4148555', '2017-06-16 11:07:02', '2017-06-16 11:09:00', b'1', null, null, null, null, null, null, null), ('8142', '8142', '2', '0', null, '344', '', '热热热', '', '15323456543', '23454566', '2017-06-16 11:10:48', '2017-06-16 11:10:48', b'0', null, null, null, null, null, null, null), ('8143', '8143', '2', '0', null, '3441', '', '热热热', '', '15565325456', '54545345', '2017-06-16 11:12:18', '2017-06-16 11:12:19', b'0', null, null, null, null, null, null, null), ('8144', '8144', '2', '0', null, '3441', '7ltv6eal', '热热热', '', '15565325456', '54545345', '2017-06-16 11:12:18', '2017-06-16 11:12:42', b'0', null, null, null, null, null, null, null), ('8145', '8145', '2', '0', null, '344', 'yb275xwq', '热热热', '', '15323456543', '23454566', '2017-06-16 11:10:48', '2017-06-16 11:15:31', b'1', null, null, null, null, null, null, null), ('8146', '8146', '2', '0', null, '3441', '7ltv6eal', '热热热', '', '15565325456', '54545345', '2017-06-16 11:12:18', '2017-06-16 11:23:08', b'1', null, null, null, null, null, null, null), ('8147', '8147', '2', '0', null, 'yyy', '', 'yyy', '', '13562548652', '789546', '2017-06-16 11:28:21', '2017-06-16 11:28:22', b'0', null, null, null, null, null, null, null), ('8148', '8148', '2', '0', null, null, 'zb60msb3', null, null, null, null, null, '2017-06-16 11:29:12', null, null, null, null, null, null, null, null), ('8149', '8149', '2', '0', null, 'lzg46153', '', '刘志国', 'lzg46153@126.com', '18841263820', '805539101', '2017-06-19 10:11:51', '2017-06-19 10:11:52', b'0', null, null, null, null, null, null, null), ('8150', '8150', '2', '0', null, 'lzg461533', '', '刘志国', 'lzg4@123.com', '18841263820', '805539101', '2017-06-19 10:13:18', '2017-06-19 10:13:19', b'0', null, null, null, null, null, null, null), ('8151', '8151', '2', '0', null, 'dddddd', '', 'dddddd', '', '18812341234', '805539101', '2017-06-19 10:14:02', '2017-06-19 10:14:02', b'0', null, null, null, null, null, null, null), ('8152', '8152', '2', '0', null, 'dddddd', 'turdt5a9', 'dddddd', '', '18812341234', '805539101', '2017-06-19 10:14:02', '2017-06-19 10:14:12', b'1', null, null, null, null, null, null, null), ('8153', '8153', '2', '0', null, 'lzg461533', 'ju6k5uub', '刘志国', 'lzg4@123.com', '18841263820', '805539101', '2017-06-19 10:13:18', '2017-06-19 10:14:15', b'1', null, null, null, null, null, null, null), ('8154', '8154', '2', '0', null, 'lzg46153', 'g1kihvjm', '刘志国', 'lzg46153@126.com', '18841263820', '805539101', '2017-06-19 10:11:51', '2017-06-19 10:14:18', b'1', null, null, null, null, null, null, null), ('8155', '8155', '2', '0', null, 'yyy', 'zb60msb3', 'yyy', '', '13562548652', '789546', '2017-06-16 11:28:21', '2017-06-19 10:14:21', b'1', null, null, null, null, null, null, null), ('8156', '8156', '2', '0', null, 'lzg461533', '', '刘志国', '123@123.com', '18841263820', '805539101', '2017-06-19 10:20:38', '2017-06-19 10:20:39', b'0', null, null, null, null, null, null, null), ('8157', '8157', '2', '0', null, 'sdddsd', '', 'ldldddsds', '123@123.com', '18841263820', '888888888', '2017-06-19 10:21:46', '2017-06-19 10:21:47', b'0', null, null, null, null, null, null, null), ('8158', '8158', '2', '0', null, 'sdddsd', 'ompoawb5', 'ldldddsds', '123@123.com', '18841263820', '888888888', '2017-06-19 10:21:46', '2017-06-19 10:23:38', b'1', null, null, null, null, null, null, null), ('8159', '8159', '2', '0', null, 'admin2', '', '刘志国', '123@126.com', '18800000000', '805539101', '2017-06-19 10:56:09', '2017-06-19 10:56:09', b'0', null, null, null, null, null, null, null), ('8160', '8160', '2', '0', null, '的实打实的', '', '了整理资料', '123@123.com', '18811111111', '805539101', '2017-06-19 10:58:39', '2017-06-19 10:58:40', b'0', null, null, null, null, null, null, null), ('8161', '8161', '2', '0', null, '的实打实的', 'wm2jmsyz', '了整理资料', '123@123.com', '18811111111', '805539101', '2017-06-19 10:58:39', '2017-06-19 11:02:30', b'1', null, null, null, null, null, null, null), ('8162', '8162', '2', '0', null, 'admin2', '63m9n7sn', '刘志国', '123@126.com', '18800000000', '805539101', '2017-06-19 10:56:09', '2017-06-19 11:13:54', b'0', null, null, null, null, null, null, null), ('8163', '8163', '2', '0', null, 'yyy', '', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-19 18:36:15', b'0', null, null, null, null, null, null, null), ('8164', '8164', '2', '0', null, null, 'z2ezhire', null, null, null, null, null, '2017-06-19 18:37:08', null, null, null, null, null, null, null, null), ('8165', '8165', '2', '0', null, null, '4vqalg7a', null, null, null, null, null, '2017-06-19 18:37:12', null, null, null, null, null, null, null, null), ('8166', '8166', '2', '0', null, null, 'rue234s3', null, null, null, null, null, '2017-06-19 18:37:32', null, null, null, null, null, null, null, null), ('8167', '8167', '2', '0', null, 'yyy', 'f0mqjze9', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-19 18:38:17', b'0', null, null, null, null, null, null, null), ('8168', '8168', '2', '0', null, 'yyy', 'f0mqjze9', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-19 18:38:57', b'0', null, null, null, null, null, null, null), ('8169', '8169', '2', '0', null, 'yyy', 'f0mqjze9', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-19 18:41:02', b'0', null, null, null, null, null, null, null), ('8170', '8170', '2', '0', null, 'yyy', 'f0mqjze9', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-22 11:01:03', b'0', null, null, null, null, null, null, null), ('8171', '8171', '2', '0', null, '5345345345', '', '4353534', '45454@qq.com', '13569875536', '78522565', '2017-06-27 14:12:26', '2017-06-27 14:12:27', b'0', null, null, null, null, null, null, null), ('8172', '8172', '2', '0', null, '5345345345', 'xfzk9k33', '4353534', '45454@qq.com', '13569875536', '78522565', '2017-06-27 14:12:26', '2017-06-27 14:15:13', b'0', null, null, null, null, null, null, null), ('8173', '8173', '2', '0', null, '5345345345', 'xfzk9k33', '4353534', '45454@qq.com', '13569875536', '78522565', '2017-06-27 14:12:26', '2017-06-27 14:16:35', b'0', null, null, null, null, null, null, null), ('8174', '8174', '2', '0', null, '5345345345', 'xfzk9k33', '4353534', '45454@qq.com', '13569875536', '78522565', '2017-06-27 14:12:26', '2017-06-27 14:19:24', b'0', null, null, null, null, null, null, null), ('8175', '8175', '2', '0', null, 'yyy', 'f0mqjze9', 'yyy', '456@qq.com', '13562487545', '12385487', '2017-06-19 18:36:14', '2017-06-27 17:02:27', b'1', null, null, null, null, null, null, null), ('8176', '8176', '2', '0', null, '5345345345', 'xfzk9k33', '4353534', '45454@qq.com', '13569875536', '78522565', '2017-06-27 14:12:26', '2017-06-27 17:02:30', b'1', null, null, null, null, null, null, null), ('8177', '8177', '2', '0', null, 'zhangyu', '', '张与', '58651@qq.com', '13568479562', '4444425', '2017-06-27 17:03:29', '2017-06-27 17:03:30', b'0', null, null, null, null, null, null, null), ('8178', '8178', '2', '0', null, 'zhangyu', 'ztgi9gi3', '张与', '58651@qq.com', '13568479562', '4444425', '2017-06-27 17:03:29', '2017-06-27 17:03:49', b'0', null, null, null, null, null, null, null), ('8179', '8179', '2', '0', null, 'zhang56', '', '张散散', '789563@qq.com', '13652648956', '458621', '2017-06-27 17:06:25', '2017-06-27 17:06:25', b'0', null, null, null, null, null, null, null), ('8180', '8180', '2', '0', null, null, '6pmez21k', null, null, null, null, null, '2017-06-27 17:11:08', null, null, null, null, null, null, null, null), ('8181', '8181', '2', '0', null, 'lihua', '', '梨花', '5656565@qq.com', '13568956235', '458621', '2017-06-27 17:22:48', '2017-06-27 17:22:48', b'0', null, null, null, null, null, null, null), ('8182', '8182', '2', '0', null, 'lihua', 'dztp6ac5', '梨花', '5656565@qq.com', '13568956235', '458621', '2017-06-27 17:22:48', '2017-06-27 18:27:40', b'0', null, null, null, null, null, null, null), ('8183', '8183', '2', '0', null, 'yangzihong', '', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:37:01', b'0', null, null, null, null, null, null, null), ('8184', '8184', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:37:59', b'0', null, null, null, null, null, null, null), ('8185', '8185', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:39:22', b'0', null, null, null, null, null, null, null), ('8186', '8186', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:40:46', b'0', null, null, null, null, null, null, null), ('8187', '8187', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:41:30', b'0', null, null, null, null, null, null, null), ('8188', '8188', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:52:13', b'0', null, null, null, null, null, null, null), ('8189', '8189', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 20:56:43', b'0', null, null, null, null, null, null, null), ('8190', '8190', '2', '0', null, 'lihua', 'dztp6ac5', '梨花', '5656565@qq.com', '13568956235', '458621', '2017-06-27 17:22:48', '2017-06-27 21:15:39', b'0', null, null, null, null, null, null, null), ('8191', '8191', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-27 21:15:45', b'0', null, null, null, null, null, null, null), ('8192', '8192', '2', '0', null, '66666', '', '狸漱', '654789@qq.com', '15698745621', '4569874', '2017-06-27 21:16:42', '2017-06-27 21:16:43', b'0', null, null, null, null, null, null, null), ('8193', '8193', '2', '0', null, '66666', '31y4m400', '狸漱', '654789@qq.com', '15698745621', '4569874', '2017-06-27 21:16:42', '2017-06-27 21:16:49', b'0', null, null, null, null, null, null, null), ('8194', '8194', '2', '0', null, '66666', '31y4m400', '狸漱', '654789@qq.com', '15698745621', '4569874', '2017-06-27 21:16:42', '2017-06-27 21:17:05', b'0', null, null, null, null, null, null, null), ('8195', '8195', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-28 19:31:48', b'0', null, null, null, null, null, null, null), ('8196', '8196', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-29 19:36:23', b'0', null, null, null, null, null, null, null), ('8197', '8197', '2', '0', null, null, 'md2jnugi', null, null, null, null, null, '2017-06-29 19:42:37', null, null, null, null, null, null, null, null), ('8198', '8198', '2', '0', null, 'yangzihong', 'yrrzeapr', '杨自鸿', 'yangzihong_2008@163.com', '15377491567', '3333333', '2017-06-27 20:37:00', '2017-06-30 15:34:58', b'0', null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `userext`
-- ----------------------------
DROP TABLE IF EXISTS `userext`;
CREATE TABLE `userext` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `AppUserId` int(11) DEFAULT NULL COMMENT '在具体应用User表中的Id',
  `AppId` int(11) DEFAULT NULL,
  `OrganizeId` int(11) DEFAULT NULL,
  `OrganizeIdName` varchar(50) DEFAULT NULL,
  `Account` varchar(50) DEFAULT NULL,
  `Password` varchar(50) DEFAULT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `Mail` varchar(50) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `QQ` varchar(50) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `ModifyDate` datetime DEFAULT NULL,
  `DeleteFlag` bit(1) DEFAULT NULL,
  `groupId` int(11) DEFAULT NULL,
  `Birth` date DEFAULT NULL COMMENT '出生年月',
  `EducationId` int(11) DEFAULT NULL COMMENT '学历',
  `DepartmentId` int(11) DEFAULT NULL COMMENT '所属部门ID',
  `PostId` int(11) DEFAULT NULL COMMENT '所属岗位ID',
  `Quality` varchar(50) DEFAULT NULL COMMENT '资质',
  `WorkTypeId` int(11) DEFAULT NULL COMMENT '工种ID',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `userfavorite`
-- ----------------------------
DROP TABLE IF EXISTS `userfavorite`;
CREATE TABLE `userfavorite` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserId` int(11) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  `Type` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `userfavorite`
-- ----------------------------
BEGIN;
INSERT INTO `userfavorite` VALUES ('3', '1', '3', '3'), ('4', '1', '4', '4');
COMMIT;

-- ----------------------------
--  Table structure for `usermenu`
-- ----------------------------
DROP TABLE IF EXISTS `usermenu`;
CREATE TABLE `usermenu` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserId` int(11) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  `Type` int(6) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `usermenu`
-- ----------------------------
BEGIN;
INSERT INTO `usermenu` VALUES ('1', '1', '178', null), ('41', '2', '170', '-1'), ('42', '2', '193', '1'), ('43', '2', '171', '-1'), ('44', '2', '172', '-1'), ('45', '2', '173', '-1'), ('46', '2', '174', '-1'), ('47', '2', '175', '-1'), ('48', '2', '176', '0'), ('49', '2', '177', '-1'), ('50', '2', '178', '-1'), ('51', '2', '179', '-1'), ('52', '2', '180', '-1'), ('53', '2', '181', '-1'), ('54', '2', '182', '-1'), ('55', '2', '183', '-1');
COMMIT;

-- ----------------------------
--  Table structure for `usermenuoperation`
-- ----------------------------
DROP TABLE IF EXISTS `usermenuoperation`;
CREATE TABLE `usermenuoperation` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserId` int(11) DEFAULT NULL,
  `MenuOperationId` int(11) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `Type` int(6) DEFAULT NULL,
  `MenuId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `usermenuoperation`
-- ----------------------------
BEGIN;
INSERT INTO `usermenuoperation` VALUES ('1', '3', '3', 'del', '0', null), ('2', '1', '1', null, null, '178'), ('3', '1', '2', null, null, '178'), ('4', '1', '4', null, null, '178'), ('6', '8131', '1', null, null, null), ('7', '1', '3', null, null, '175'), ('9', '1', '2', null, null, '101'), ('11', '1', '2', null, '1', '89'), ('12', '1', '36', null, null, '104'), ('13', '1', '34', null, null, '104'), ('14', '1', '35', null, null, '105'), ('15', '2', '36', null, null, '178'), ('17', '1', '2', null, '0', '101'), ('19', '1', '36', null, '-1', '104'), ('21', '2', '2', null, '0', '177'), ('22', '2', '3', null, '1', '177'), ('23', '2', '34', null, '1', '177'), ('24', '2', '4', null, '1', '177'), ('25', '2', '34', null, '1', '182'), ('26', '2', '3', null, '1', '182'), ('28', '1', '2', null, '1', '103'), ('29', '1', '2', null, '1', '104'), ('32', '1', '2', null, '0', '105'), ('33', '2', '2', null, '0', '174'), ('34', '2', '3', null, '0', '174'), ('35', '2', '1', null, '0', '174'), ('36', '2', '34', null, '1', '174'), ('37', '2', '35', null, '1', '174'), ('38', '2', '36', null, '1', '174'), ('39', '1', '35', null, '0', '110'), ('40', '1', '36', null, '0', '110'), ('41', '2', '1', null, null, '172'), ('43', '2', '3', null, null, '172'), ('44', '2', '34', null, null, '172'), ('45', '2', '4', null, null, '172'), ('46', '1', '1', null, '0', '89'), ('47', '1', '2', null, '0', '89'), ('48', '1', '1', null, '0', '90'), ('49', '1', '2', null, '0', '90'), ('50', '1', '1', null, '-1', '89'), ('51', '1', '3', null, '0', '89'), ('52', '1', '4', null, '0', '89'), ('53', '1', '34', null, '0', '89'), ('54', '1', '35', null, '0', '89'), ('55', '1', '35', null, '1', '89'), ('56', '1', '36', null, '1', '89'), ('57', '1', '34', null, '1', '89'), ('58', '1', '3', null, '1', '106'), ('59', '1', '34', null, '1', '106'), ('60', '2', '35', null, '0', '177'), ('61', '2', '4', null, '0', '172'), ('62', '2', '4', null, '-1', '172'), ('63', '2', '39', null, '1', '183'), ('64', '2', '38', null, '1', '183'), ('65', '2', '37', null, '1', '183'), ('66', '2', '4', null, '0', null), ('67', '2', '4', null, '1', null), ('68', '2', '36', null, '0', null), ('69', '2', '36', null, '-1', null), ('70', '2', '4', null, '-1', null), ('71', '2', '37', null, '-1', null), ('72', '2', '38', null, '-1', null), ('73', '2', '39', null, '-1', null), ('74', '2', '4', null, '0', null), ('75', '2', '36', null, '0', null), ('76', '2', '37', null, '0', null), ('77', '2', '38', null, '0', null), ('78', '2', '4', null, '-1', null), ('79', '2', '36', null, '-1', null), ('80', '2', '37', null, '-1', null), ('81', '2', '38', null, '-1', null), ('82', '2', '36', null, '0', '172'), ('83', '2', '4', null, '0', '194'), ('84', '2', '37', null, '0', '194'), ('85', '2', '36', null, '1', '194'), ('86', '2', '36', null, '-1', '194'), ('87', '2', '36', null, '0', '194'), ('88', '2', '36', null, '1', '194'), ('89', '2', '4', null, '1', '194'), ('90', '2', '36', null, '0', '194'), ('91', '2', '36', null, '-1', '194'), ('92', '2', '4', null, '-1', '194'), ('93', '2', '36', null, '0', '194'), ('94', '2', '37', null, '1', '194'), ('95', '2', '37', null, '1', '172'), ('96', '2', '38', null, '0', '172'), ('97', '2', '38', null, '-1', '172'), ('98', '2', '38', null, '0', '172'), ('99', '2', '38', null, '-1', '172'), ('100', '2', '38', null, '0', '172'), ('101', '2', '38', null, '-1', '172'), ('102', '2', '38', null, '0', '172'), ('103', '2', '38', null, '-1', '172'), ('104', '2', '38', null, '0', '172'), ('105', '2', '38', null, '-1', '172'), ('106', '2', '36', null, '-1', '172'), ('107', '2', '37', null, '-1', '172'), ('108', '2', '4', null, '0', '172'), ('109', '2', '36', null, '0', '172'), ('110', '2', '36', null, '1', '172');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
